package server.dao.util;

final public class DatabaseConstants {

	public static final String	URL							= "jdbc:mysql://localhost/argame";
	public static final String	USERNAME					= "root";
	public static final String	PASSWORD					= "";
	public static final String	USER_TABLE					= "Users";
	public static final String	USER_TABLE_USERID			= "uid";
	public static final String	USER_TABLE_PASSWORD			= "password";
	public static final String	USER_TABLE_EMAIL			= "email";
	public static final String	USER_TABLE_GROUPID			= "GID";

	public static final String	CHECKPOINT_TABLE			= "checkpoints";
	public static final String	CHECKPOINT_TABLE_ID			= "checkpointID";
	public static final String	CHECKPOINT_TABLE_WIDTH		= "width";
	public static final String	CHECKPOINT_TABLE_LENGTH		= "length";
	public static final String	CHECKPOINT_TABLE_HEIGHT		= "leight";
	public static final String	CHECKPOINT_TABLE_INFO		= "info";

	public static final String	GROUP_TABLE					= "groups";
	public static final String	GROUP_TABLE_ID				= "gid";
	public static final String	GROUP_TABLE_NAME			= "gName";
	public static final String	GROUP_TABLE_PASSWORD		= "gPassword";

	public static final String	GROUP_RIGHT_TABLE			= "groupRights";
	public static final String	GROUP_RIGHT_TABLE_GROUPID	= "groupID";
	public static final String	GROUP_RIGHT_TABLE_RIGHTID	= "rightID";

	public static final String	REACHED_TABLE				= "reachedcp";
	public static final String	REACHED_TABLE_USERID		= "uid";
	public static final String	REACHED_TABLE_CHECKPOINTID	= "cpid";
	public static final String	REACHED_TABLE_TIME			= "time";

	public static final String	RIGHT_TABLE					= "rights";
	public static final String	RIGHT_TABLE_RIGHTID			= "rid";
	public static final String	RIGHT_TABLE_RIGHT_NAME		= "rname";

	public static final String	USER_RIGHT_TABLE			= "userRights";
	public static final String	USER_RIGHT_TABLE_USERID		= "uid";
	public static final String	USER_RIGHT_TABLE_RIGHTID	= "rid";

}
